UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8tc4WUOPMHzerIzuLltuKttZ28KN3w5jYd3x44kPosU='
WHERE
key_id = 'd5844a5f0e5696e2b73036693c8238fbb134a9b0afebf36ab3d525252cc65b43'
AND (
token = '8tc4WUOPMHzerIzuLltuKttZ28KN3w5jYd3x44kPosU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)