UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NxOnX7AsGHllbvqkHjg/+svX+TxYGaKbJACE4wEnm6s='
WHERE
key_id = '0f231ab37729348d917102108a77e23e92c939105f5798fd4ec530446af35cb5'
AND (
token = 'NxOnX7AsGHllbvqkHjg/+svX+TxYGaKbJACE4wEnm6s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)