UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I0TEDYidmHUQmyCQatXj5CB73BqkNU30vkJQ/qFJg50='
WHERE
key_id = '0cc18b298b576298720f274ae8e6734d38c679176450d00f65d59d5276ba3ad2'
AND (
token = 'I0TEDYidmHUQmyCQatXj5CB73BqkNU30vkJQ/qFJg50='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)