UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WK7tF9O4a3AIi4sx6+bi2gdTv9IA4i8smC+BO8iitmg='
WHERE
key_id = '9b61782eb9a137f16fa70de1a7e02345b466ae4c40862c193720134c2da98fc3'
AND (
token = 'WK7tF9O4a3AIi4sx6+bi2gdTv9IA4i8smC+BO8iitmg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)