UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C6DAj1rsSIv67IeoqxN3hS4WPF6G7iHSDNHvWs9lfVw='
WHERE
key_id = '2889b0d2c911080688bee63f3cb65565418683d8098e100cb1f17fb3c1113d36'
AND (
token = 'C6DAj1rsSIv67IeoqxN3hS4WPF6G7iHSDNHvWs9lfVw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)