UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a/P/YSO3La1OShAWXuXjY2Ozh9cl2VfaGLGI3M8T13I='
WHERE
key_id = 'c0511c0452d6f02de94ef801b3dd023c7b4b3dff35fe4bf349af80f7ce18d5a2'
AND (
token = 'a/P/YSO3La1OShAWXuXjY2Ozh9cl2VfaGLGI3M8T13I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)