UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oXOfrLe9trjgG06zel3nRi3fjnT/M2YNRJy1kmCqf7M='
WHERE
key_id = '1f58fef0c9bc57ae3d07ce55e6950e538a59001ba808cf4d3a98b66d23b70e1a'
AND (
token = 'oXOfrLe9trjgG06zel3nRi3fjnT/M2YNRJy1kmCqf7M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)