UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jIoWrwrABiellpICxNdH9u66UZrwGYsGpjawhkxcx80='
WHERE
key_id = '7c31152e98e5a2e444aa9d8a5b81c01ee321c71f45add4ee5d9c478d6e5b08a5'
AND (
token = 'jIoWrwrABiellpICxNdH9u66UZrwGYsGpjawhkxcx80='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)