UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '12YaSNKqCW6Hlijvj+9D60GkU8piWD/R7cHWz+Cmaes='
WHERE
key_id = '2867a5e9be59b267e226854397462ab3f4aa7ab2fd377f1a0370b6e5dce0c313'
AND (
token = '12YaSNKqCW6Hlijvj+9D60GkU8piWD/R7cHWz+Cmaes='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)