UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kLZnqN3uxK8PPNt7vrNsN/yK34uwRDN58YkYygU/XlU='
WHERE
key_id = '5e9699dcc4b56448a30096c6b56d421cbb428fb04c8690cdcc93e5a9c6b2c405'
AND (
token = 'kLZnqN3uxK8PPNt7vrNsN/yK34uwRDN58YkYygU/XlU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)