UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vy5SS3gF01YiZw5nSWTVQwODk0K0Yphnwp25a/5yGMU='
WHERE
key_id = 'ad7dabf62422b4737e3bfc16eacef227c58ddd104c1057a8a12adc52a7a45a11'
AND (
token = 'vy5SS3gF01YiZw5nSWTVQwODk0K0Yphnwp25a/5yGMU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)