UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HYirM7WLZgKqHfzxFiue7OWCYLEcygv618qTjBQAJOM='
WHERE
key_id = '6702c444c67c76330a3c69f16252c57533d5bec27cba709655f0efbb9dc22854'
AND (
token = 'HYirM7WLZgKqHfzxFiue7OWCYLEcygv618qTjBQAJOM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)