UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Dx/C3Bvmv0pA57Yo2QOA9aoBwa7jf7qLzgAC21u/Cc='
WHERE
key_id = '46aad145b14104a23264a5d550b023582e6033fed00b171c8c306afc24c13ada'
AND (
token = '7Dx/C3Bvmv0pA57Yo2QOA9aoBwa7jf7qLzgAC21u/Cc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)