UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uomBi1DSE+g8Ki8qX0tNabNkJw8fS35Gp/5hRTQNNrE='
WHERE
key_id = 'caa7aff6f64ca1afdce1337525900dd47f8722577f853151c3deab3e91a4a222'
AND (
token = 'uomBi1DSE+g8Ki8qX0tNabNkJw8fS35Gp/5hRTQNNrE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)