UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'O4EKroKJI4WpxaTlc8oHIqT94dNK6bdYigrX5RcLFKw='
WHERE
key_id = 'd8fc1613ba53d4655f6d6911a7631de671589ca4145a4b6f49b424b4a7e7eb80'
AND (
token = 'O4EKroKJI4WpxaTlc8oHIqT94dNK6bdYigrX5RcLFKw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)