UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zlpld44aM1rDMvwoT4uNaJdhpfFQ6wkOZRGtU98T3xE='
WHERE
key_id = '4a52c52244f5045c24d7896fa9ace7d193c7691dd4e6db4f4f03a3627ec9d6b9'
AND (
token = 'zlpld44aM1rDMvwoT4uNaJdhpfFQ6wkOZRGtU98T3xE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)