UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bcnR6kFjvSESb3belwGHTHocqIYWF7XroD4JKX+ckAs='
WHERE
key_id = '84b30c283476b8c8401303de47b0245a15dfbcf1aed161f03f93c9d70c5ff595'
AND (
token = 'bcnR6kFjvSESb3belwGHTHocqIYWF7XroD4JKX+ckAs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)