UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bda+CKEygI+KC5by6uA9WMqy46NjadbnYZI1E1+jxMg='
WHERE
key_id = '8395d3c0a345849c45ef23486f716ce509c93eb25a9f2807170a4884bccbb3b2'
AND (
token = 'Bda+CKEygI+KC5by6uA9WMqy46NjadbnYZI1E1+jxMg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)