UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HSgBjcBVwmNDXQ3EMOn0Zo4YYqrbsxxD+ixilUL83aM='
WHERE
key_id = '45431f482431b315868a471d0344d231c4069609722a62eb161e2822d0eb8b8c'
AND (
token = 'HSgBjcBVwmNDXQ3EMOn0Zo4YYqrbsxxD+ixilUL83aM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)