UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gkc80n7E7WASKG7mtQTdjPjhfLKWZ7vKfaNFZt/9W/k='
WHERE
key_id = 'd14bdd0ea6795f64b67075ae36b673d4c767a8f347a17c07e164616b7d4be61f'
AND (
token = 'gkc80n7E7WASKG7mtQTdjPjhfLKWZ7vKfaNFZt/9W/k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)