UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HUX1VYD1Ixq4bJGgXTJOVgyccnsAoO8Peelq49ovjtM='
WHERE
key_id = 'bab99e4f4eb3c20ba38f32f7c1442a98201d9b9d529818c005a8d1250edf2a71'
AND (
token = 'HUX1VYD1Ixq4bJGgXTJOVgyccnsAoO8Peelq49ovjtM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)