UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J9ZvBsEkxW25wYzwiaq01tm/D5hW6HF0J4BTFIdfOdo='
WHERE
key_id = '0e67fabb9c6725c1cd0f380839301f411161d768040a4cc61ab7c0e83b378909'
AND (
token = 'J9ZvBsEkxW25wYzwiaq01tm/D5hW6HF0J4BTFIdfOdo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)