UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'blOmPn5RLYFY75Cz2HE4/zr8SFQN95T0CPYeZpWupkA='
WHERE
key_id = 'b8d8be189601c196583305b7ac66201b5d3a97200b617ca2345a22ec9ff40123'
AND (
token = 'blOmPn5RLYFY75Cz2HE4/zr8SFQN95T0CPYeZpWupkA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)