UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pgpn4cwV8Veoh7wFCKQjhCa9G7OAbDE3MZiwou5u1Mw='
WHERE
key_id = '31f49e1cebe5a63a2dc5c5203525fc0e7bd6578cf782a9f6f2f379952fd54eff'
AND (
token = 'Pgpn4cwV8Veoh7wFCKQjhCa9G7OAbDE3MZiwou5u1Mw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)