UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nmFAARsA1gDs91mLC3S3sZe1ud6tCLjZ76IV+34sTD0='
WHERE
key_id = '8eae2991dd6fff06b1f0e1d83583ef41f5ed3360865876c45cd1b4e51197ec8a'
AND (
token = 'nmFAARsA1gDs91mLC3S3sZe1ud6tCLjZ76IV+34sTD0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)