UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9UUVJDzzfnCn1Rlavf71ZvzGKV7IMJkRMtnNMU4nmNY='
WHERE
key_id = '46d8211e60822f198580c0ba060b1034541f8985d196eefb095c2a63c9c85873'
AND (
token = '9UUVJDzzfnCn1Rlavf71ZvzGKV7IMJkRMtnNMU4nmNY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)