UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iSJkKRNdoqvnb7jVdx4jbPttlRkMCCkvPqGdsWEHxrY='
WHERE
key_id = '96fccb701126ae43826e73cc68c6b8f682dc47204429a23749693e902279f4b8'
AND (
token = 'iSJkKRNdoqvnb7jVdx4jbPttlRkMCCkvPqGdsWEHxrY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)