UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6XogdAgj9uLot9aak+U2jUd0P2GAgflLcY05trZnBME='
WHERE
key_id = '0b142dd1def7e9b6d3dd80980c6ea32f95f1bf5518cc24fd7e36d96a9409e941'
AND (
token = '6XogdAgj9uLot9aak+U2jUd0P2GAgflLcY05trZnBME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)