UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+EKgqLykVdFcMD7IVOrYLVUSxh0Yqrz0zxIc9r7fZ9Q='
WHERE
key_id = 'b0a13461200c8e608cc91043625742b18b8206b752b6db86365afcbda9a1b86f'
AND (
token = '+EKgqLykVdFcMD7IVOrYLVUSxh0Yqrz0zxIc9r7fZ9Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)