UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nWXI1cCh4gNWoo5Anoqy4xF8ABT1u4Q1rM4qAWsg39k='
WHERE
key_id = 'b7a1b313c49a193710d94085a4f4ec85a8e98202a94725e151cc9d0c88a72794'
AND (
token = 'nWXI1cCh4gNWoo5Anoqy4xF8ABT1u4Q1rM4qAWsg39k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)