UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KkekZEnYkopMnPh596G/cJPUCWujIpDYvsNMw0GQYao='
WHERE
key_id = '47dbee4ae200584876c29b7344f24a2fb702a4b384f2c2fed178426ffc6f84e8'
AND (
token = 'KkekZEnYkopMnPh596G/cJPUCWujIpDYvsNMw0GQYao='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)